Re: bcp accent problem



Sitar (Sitar@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Well the problem on the Samba server side has been fixed. It did not
change much on my side. Well instead of having the accents dropped now I
have weird characters instead but I'm not sure if it is due to the
change of settings on the Samba server or not.

Weird characters are a lot better than no characters at all.

Could you care to give a sample of how the data gets garbled? Please
posted the garbled data as hex string (convert(binary), so that they
don't get distored in news transsport. Of course, you need to include
the original strings as well.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: more than 8192 characters in text file output
    ... It's encoding UTF16 and that's screwing thigns up. ... the output are being truncated at 8192 characters. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: Default charset in sqlserver 2000? / jtds
    ... > The columns share this collation. ... points are control characters to 8859-1. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Stored proc with version number ?
    ... in addition to letter characters from other languages. ... Certain symbols at the beginning of an identifier have special meaning ... in SQL Server. ... I choose> the existing stored proc uspTableSave and right click Properties. ...
    (microsoft.public.sqlserver.programming)
  • Re: IRowsetFastLoad and nvarchar (1) fields
    ... definition in my DDL - I wonder if nvarchar really does ... That means characters. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Can you use osql in DTS?
    ... each one of these queries has in it the same first 18 characters (or ... it from Query #3. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)