Nicky Please check your database collation, both of the default (main ?) database and the specific one used
Roey On Mon, Aug 3, 2009 at 9:04 PM, Avishalom Shalit <[email protected]> wrote: > > 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 _______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
