Skip to Content.
Sympa Menu

freetds - Re: [freetds] are varchar and nvarchar actually the same? [Was: hex(92), freeTDS and MS SQL]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Lapo Luchini <lapo AT lapo.it>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] are varchar and nvarchar actually the same? [Was: hex(92), freeTDS and MS SQL]
  • Date: Mon, 29 Jan 2007 10:37:53 +0100

ZIGLIO, Frediano, VF-IT wrote:
>> Server: SQL server 7
>> Using FreeTDS 0.63 with official patch to use CP1252 on server "iso1"
>> Client encoding: UTF-8
> Well... there's no official 0.63 patch. 0.64 and HEAD are updated, there is
> a post 0.64 patch.

Yesss, what I meant was actually something more like "with the relevant
part of the official post-0.64-patch applied over 0.63", but I was a
tiny bit too terse, as usual. ;-)

>> Is SQLServer7 purposefully converting what it is received in
>> CP1252 only
>> to be converted back to UCS2 thereafter???
> I think so.
> The reason it's not so easy. You should solve with
> mssql_query("UPDATE P SET c = '$var', n = N'$var' WHERE i = 1");

Oookay. A bit of ignorance on my side here, but I prefer it this way:
this way the problem is easily solved, eheh.

I just tried, I can confirm it is working using the N'':
W: c3 a0 e2 80 98 e2 80 99 e2 80 9c e2 80 9d c3 85 c5 ae e7 a7 81
C: c3 a0 e2 80 98 e2 80 99 e2 80 9c e2 80 9d c3 85 55 3f
N: c3 a0 e2 80 98 e2 80 99 e2 80 9c e2 80 9d c3 85 c5 ae e7 a7 81

Lapo





Archive powered by MHonArc 2.6.24.

Top of Page