NNNOOOOO you've doomed us both -- vish
2009/8/3 Omer Zak <[email protected]>: > Yes, there is something in Python. > I blogged about this subject almost two years ago. See: > http://www.zak.co.il/tddpirate/2007/12/25/choosing-a-python-module-for-accessing-microsoft-sql-server-unicode-data/ > > --- Omer > > > On Mon, 2009-08-03 at 14:00 +0300, Avishalom Shalit wrote: >> http://www.perlmonks.org/?node_id=719216 >> was useful for me. >> especially the iconv tip (but i was going the other way , exporting >> from mssql, which gives utf-16 files ) >> >> >> if that doesn't work, there's probably something in python ;-) >> -- vish >> >> >> >> 2009/8/3 Nicky Pappo <[email protected]>: >> > Hi, >> > I am trying to read a file (Hebrew characters), and store data from it >> > thought DBI into SQL server. >> > Characters are garbaged after the Insert command. >> > Any ideas? >> > >> > Thanks Nicky Pappo >> > [email protected] >> > >> > >> > Here the relevant piece from the code: >> > >> > >> > #!/usr/bin/perl >> > >> > use strict; >> > use DBI; >> > >> > >> > my $dbconnect="SQLEXPRESS"; #the odbc connection >> > my $paramvalue = ""; >> > my $filename="1"; >> > my $paramtype="type"; >> > my $sqlstatement; >> > >> > open(DAT, "test.txt" ) || die("Could not open file!"); >> > binmode DAT, ":utf8"; >> > while (<DAT>){ >> > $paramvalue .= $_; >> > } >> > >> > >> > my $dbh = DBI->connect("dbi:ODBC:$dbconnect"); >> > >> > >> > $sqlstatement= "insert into parameters >> > (filename,ParameterType,ParameterValue) >> > values('$filename','$paramtype',N'$paramvalue')"; >> > #setUTF8($sqlstatement); >> > my $sth = $dbh->prepare($sqlstatement); >> > $sth->execute(); > -- > $ python >>>> type(type(type)) > <type 'type'> My own blog is at http://www.zak.co.il/tddpirate/ > My opinions, as expressed in this E-mail message, are mine alone. > They do not represent the official policy of any organization with which > I may be affiliated in any way. > WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html > > _______________________________________________ > Perl mailing list > [email protected] > http://mail.perl.org.il/mailman/listinfo/perl > _______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
