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

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

[wayneedmondson]

Thanks Andrew. Interesting topic. Thumbs up!!

[RohithKK-uhpp]

I have become good code er now. Thank you sir.

[shinrafahell]

Very complex topic but also very interesting.

[PankajNegi]

Great Sir I really Enjoy this video
Sir, it is requested to make such video series in Google Sheets Macros

[learnwithme]

But ChrW() and AscW() were not used to transfer the text to a variable in the final script ? I'm trying to do something similar but when i use ChrW() and AscW(), I only get the value of one character - i don't get the whole sentence then when i tried to input data by just saving it as a variable, I just get the question marks

[levelupexcelskill]

Could you please make a video for advanced array, collection and vba you to please make a video how to compare 1 lac above data between two workbook with vba

[wmobvst]

I'm trying to scrape a web page following your videos, all was great till I got stuck on a datepicker with a hebrew string date. Now I can't pass the date from excel to the page. This solution only applies to one character at a time. Any advice?