Re: French characters are not imported properly with bcp



Wael (sedky@xxxxxxxxxxxxxx) writes:
I tried -C RAW but i got an error.

An error? Care to specify what? It's difficult to assist without knowing
the error message.

If you check the windows regional
settings, you'll see 863 is the code page for Canadian French.

Regional and Language Options\Advanced

Yes, I also see that it is an OEM code page. Is the data file in this
code page?


--
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: New Books Online Update Available.
    ... The exact error message you get. ... The version of SQL Server on the machine. ... This version of the Books Online will ... On the Download Center page, ...
    (microsoft.public.sqlserver.server)
  • Re: Convert CHAR YYYYMMDD to mm/dd/yyyy
    ... Moral to the story "Think globally (i.e. ISO) ... in SQL 2005 the format YYYY-MM-DD is subject to local settings ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Please Help with SQL Query Problem
    ... Since you did not post any sample data, ... it - make yourself a favour and post the error message next time. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: sql script
    ... The UPDATE statement conflicted with the REFERENCE constraint ... then you present an error message. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Using Union and Join in a single view
    ... Yes I did read the error message and it's as clear to me as it is to ... SOPNUMBE column but the rows in each table are unique. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)

Loading