opc.three (4/12/2013)

---

By default TYPE is not going to preserve Unicode data for you and I do not know of a way to setup the environment or call it where it...

Yeah, I boneheaded that one. It works now, and the file output is correct.

So, I took it and applied it to the table I want to write as a file,...

I'm running these:

set @sql='exec master..xp_cmdshell ''bcp " select * from (select '+@columns+') as t" queryout "'+ @filePath + @file_name+'" -w -t";" -T '''

exec(@sql)

set @sql='exec master..xp_cmdshell ''bcp " select ' +...

opc.three (4/12/2013)

---

It saddens me a bit that the code is accessing the command prompt and the file system from within T-SQL, especially as part of an applicaiton design, but from...

opc.three (4/12/2013)

---

It should be a quick fix to the cursor declaration I showed above so...

nick.mcdermaid (4/12/2013)

---

If I understand correctly, when looking at the same table with different clients, you can see the japanese characters in one, but not in the other? Doesn't that mean...

The other fields it's occurring in are first name, last name, and company name. Crud.

Yeah, I sort of forgot to mention that I numbered them in the order I use them. Heh.

Here's the scripted output you asked for.

https://www.dropbox.com/s/inhtv19uyo04xyk/erikd_tables.zip

I've also included the...

Absolutely. Here you go.

https://www.dropbox.com/s/sp6b6kf6z997g55/erikd.csv

opc.three (4/11/2013)

---

Sure. Post it. If you want to attach some sample UPDATE statements and the table defs too as a text file so the browser doesn't get in the way...

opc.three (4/11/2013)

---

For terminology's sake so we're speaking the same language:

ANSI = VARCHAR/CHAR

Unicode = NVARCHAR/NCHAR

In SQL Server, Unicode = UCS-2

Still not clear if all your columns are Unicode or whether you...

opc.three (4/11/2013)

---

The ? marks are a dead giveaway that non-printable ANSI characters are being pushed into an ANSI column or variable (i.e. VARCHAR or CHAR). The hollow squares might be...

Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

Heh. Curiously, I can use Python to split the file up (opening the whole file...

Heh. Curiously, I can use Python to split the file up (opening the whole file with any of...

Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

From your post I can't tell if you are using '\ n' (no space between the \ and n) as your row...