inserting korean into database

System

I'm stumped. I want to be able to insert Korean characters into a MSSQL 2005 database using perl.

I'm not sure where I'm going wrong, the database setup or the perl or the file encoding of the perl file. Do I have to change my encoding on the database to handle Korean. I can directly paste the Korean characters into the table using Microsoft SQL Server Management Studio, but I can't get them to go in via perl.

Here is some simple code I am trying.

[PHP]

use DBI;
my $host = 'sq5,1433';
my $database = 'Repositories';
my $user = '####';
my $auth = '####';
# DBD::ADO
$dsn = "Provider=sqloledb;Trusted Connection=yes;";
$dsn .= "Server=$host;Database=$database";
my $dbh = DBI->connect("dbi:ADO:$dsn",
$user,
$auth,
{ RaiseError => 1, AutoCommit => 1}
) || die "Database connection not made: $DBI::errstr";
#Prepare a SQL statement
my $two = '향찰/鄕札';
my $sql = "INSERT INTO dbo.akoreantest (test) VALUES ('" . $two . "' )";
my $sth = $dbh->prepare( $sql );
#Execute the statement
$sth->execute();

$sth->finish();
$dbh->disconnect();

[/PHP]

My goal is to get the Korean characters to be in the database. Do I have to change my code or my database settings or the encoding of my perl file? I have no idea.

Migrateduser

I think I might have it figured out.

I encoded my perl file as utf-8 and then was able to run the following and see it insert the correct characters in my MSSQL database.

use strict;
use DBI;
use DBD:DBC;
use utf8;
my $dsn = "driver={SQL Server};Server=myserver;database=mydatabase";
my $dbh = DBI->connect( "dbiDBC:$dsn", "username", "password", { AutoCommit => 1 } );
my $sql =  "insert into koreantest (test)values (N'향찰/鄕札')";
my $sth = $dbh->prepare ($sql);
$sth->execute();
$dbh->disconnect;

Note the N in front of the values in the insert section. Without it you will just see "??/??" in your fields.

On my Windows XP and 2003 server boxes it worked fine, but on Windows 2000 I believe I need to install Korean under Control Panel\Regional Settings in order for this to work since the same code is not working there. I have a restart scheduled for tomorrow and hopefully that will be the final key to the puzzle. Ahhh... so much to learn.