Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sharmarohi
Starting Member
4 Posts |
 Posted - 2007-01-10 : 23:41:39
|
| Hey guys i urgently need to know whether there is a way to use BCP to export a query out a utf8 file??????I need this asap, as im getting hounded at work for it.Cheers |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-01-11 : 00:40:19
|
you can definitely do unicode, but it might be utf16. have a look at the -w flag for bcp. try it and open up the resulting file in a hex editor to make sure of the encoding.
www.elsasoft.org |
 |
|
|
sharmarohi
Starting Member
4 Posts |
Posted - 2007-01-11 : 00:42:27
|
| Yea i tried the -w however that created a standard unicode file not a utf8 one.....im completely stuck on this one. |
|
|
|
sharmarohi
Starting Member
4 Posts |
Posted - 2007-01-11 : 00:53:27
|
| or is there completely different i can do, as all the files are in a folder.... can i do it through a dos command line? because whats happening right now is that im using bcp to transfer the files to another server and then i need to save them as utf8 |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-11 : 01:58:36
|
quote:
UTF-8 is a superset of ASCII. Since a plain ASCII string is also a valid UTF-8 string, no conversion needs to be done for existing ASCII text. Software designed for traditional extended ASCII character sets can generally be used with UTF-8 with few or no changes.UTF-8 (and UTF-16) are the standard encodings for XML documents. All other encodings must be specified explicitly either externally or through a text declaration.
Seems to me you have two option. Either leave as is (if not using unicode), or export file as XML.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
BCP UTF8 URGENT