Hi All

I am working on a database with Japanese_CI_UI collation and want to generate file in fixed byte(not characters) format. I have defined all columns as nchar and used bcp/queryout option. But I found that the file does not get generated in fixed byte format instead bcp onverts all possilbe double-byte characters to single byte. For example, Organisation_name column in my table is defined as nchar(100) but it has just got 4 japanese characters then bytes consumed by this column is 54

How can we override this implicit conversion to generate fixed byte file
Regard
Samir

Hi

Have you tried the -N flag?

John

[quoted text, click to view]
generate file in fixed byte(not characters) format. I have defined all
columns as nchar and used bcp/queryout option. But I found that the file
does not get generated in fixed byte format instead bcp onverts all possilbe
double-byte characters to single byte. For example, Organisation_name column
in my table is defined as nchar(100) but it has just got 4 japanese
characters then bytes consumed by this column is 54.
[quoted text, click to view]