Storing UTF-8 enabled strings in SQL Server with Perl and ADODB
Wednesday, June 1st, 2011In order to save you some frustrations while you are wondering why your Japanese or Chinese strings are not well saved in your Microsoft SQL Server database when using Perl in combination with OLEDB, you can do the following:
use utf8; Win32::OLE->Option( CP => Win32::OLE::CP_UTF8 );
This will tell Perl to use utf-8 encoding in your file and will make sure your strings are correctly piped to the database.