Storing UTF-8 enabled strings in SQL Server with Perl and ADODB
In 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.
Tags: perl, SQL Server
