Re: bcp accent problem
Tech-Archive recommends: Fix windows errors by optimizing your registry
Sitar (Sitar@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm importing data from formatted text files with accent (Latin1). My
database is set to French_CI_AS. I use bcp with -C"Latin1" or
-C"French_CI_AS" but bcp seems to ignore the flag and every single
accent is left behind.
That is if on column is "rené" in the source file, it becomes "ren" in the
database.
From experience, the -C flag should fix that problem but here nothing
seems to work.
For -C you specify a code page, not a collation, as I recall. Thus, if the
file is in the ANSI code page, specify -C ANSI or -C RAW.
--
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: Linked Server - Force Translate
... I had the same issue when using a connection string with same ... > see sp_addlinkedserver in Books Online for details. ... > You can also use OPENROWSET and specify a connection string with it. ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
(microsoft.public.data.oledb) - Re: Help !! How to achieve accumulative totals
... I need to be able to have a query that will give me a running total of job ... If this is SQL Server then also take a look at the CUBE / ... ROLLUP operator in Books Online. ... State what version of SQL Server you are using and specify the content ...
(microsoft.public.access.adp.sqlserver) - Re: help with stored procedure which returns an OUTPUT value
... the select statement by modifying the the single quotes in the ... You cannot specify the database name through a ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: Stored Procedure to list out user access
... Rather you are best off querying the view ... Make it a habit to always specify which version of SQL Server you are using ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
(comp.databases.ms-sqlserver) - Re: FTI, Searching and other Filters
... No matter what I specify for a search condition, ... "SQL SERVER DBA"') ... Remove the FTI from the table. ... Add an OfficeID column to the table and populate it. ...
(microsoft.public.sqlserver.fulltext) |
|
