Wise Owl Answers - How do I pass Japanese text to a stored procedure parameter in VBA?

Check out our other answers here    • Wise Owl Answers   If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link
​ to make a donation. Thanks for watching! Download files and references here
Learn how to pass Japanese characters from an Excel worksheet into a SQL Server stored procedure using the ADODB library in VBA. You'll learn the basics of character encoding systems, how to use the varchar and nvarchar data types in SQL Server, how to execute stored procedures from VBA and how to use the merge statement in SQL. As a bonus, you'll also learn the kanji for dogs, cats, puppies and kittens in Japanese! 00:00:00 The Question 00:01:11 Installing the Japanese Language in Windows 00:02:17 Typing Hiragana Characters 00:05:58 Typing Katakana Characters 00:07:49 Typing Kanji Characters 00:09:42 A Brief Summary of Character Encoding 00:13:43 Choosing the Encoding System in Notepad 00:16:23 Creating a Basic Table in SQL Server 00:17:59 The Char and VarChar Data Types 00:20:30 The NChar and NVarChar Data Types 00:22:18 Setting Collation Options 00:24:44 Typing Text into a Table 00:26:29 Inserting Japanese Characters into a Table 00:29:43 Forgetting to include the N 00:31:48 Creating a Basic Stored Procedure 00:34:44 Testing the Stored Procedure 00:36:08 Using Named Parameters 00:37:44 Using the Merge Statement 00:43:34 Testing the Merge Statement 00:46:07 Typing Japanese Characters in Excel 00:46:53 Trying to Use Japanese Characters in the VB Editor 00:49:01 The AscW and ChrW Functions 00:51:25 Using the Hex Code for a Character 00:52:39 Displaying Kanji on a Message Box 00:53:53 Referencing the ADODB Library 00:55:13 Connecting to SQL Server 00:57:43 Getting Data from SQL Server 00:59:49 Executing a Stored Procedure using VBA 01:03:23 Executing a Stored Procedure for Each Row of an Excel Table 01:08:02 Testing the System Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more