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 https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Download files and references here https://www.wiseowl.co.uk/vba-macros/...

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