Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export XML with multi-language data Expand / Collapse
Author
Message
Posted Sunday, June 15, 2008 1:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 2:41 PM
Points: 123, Visits: 301
I need a help on the follow one, please:

I use an English language SQL 2005 application. Lately I need to hold in a Synopsis field of mine ( VARCHAR(1000) )
different languages which have some special tags ( French, Spanish ).

So far was so good and quiet, but now I need to create an XML file with Spanish Synopsis, but all what I get instead of
those specal characters is a question mark. I've tried to use COLLATE, but with no result as well.

Were am I wrong?

Kind Regards!
Post #517237
Posted Tuesday, June 17, 2008 1:35 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
Have you tried changing the data type from varchar to nvarchar?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #518535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse