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 |
|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
 Posted - 2005-04-26 : 16:39:35
|
| I am saving text(as RTF) in a field as varchar(8000). It is saving correctly but if I pull up the text and it has spanish accents in it, it puts weird charachters in it. Do I need to change the data type? or something else? Thanks!BrendaIf it weren't for you guys, where would I be? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-04-26 : 20:22:40
|
| Could it be your collation setting for that column? Perhaps it's the Accent Sensitivity portion of the collation. Also, and I don't know, does Spanish require Unicode? If so, changing to the nvarchar datatype would be the way to go.HTH=================================================================Every act of conscious learning requires the willingness to suffer an injury to one's self-esteem. That is why young children, before they are aware of their own self-importance, learn so easily; and why older persons, especially if vain or important, cannot learn at all. -Thomas Szasz, author, professor of psychiatry (1920- ) |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-26 : 20:38:14
|
| My name is Inigo Montoya...you killed my father...prepare to die.Oooops, sorry, misunderstood the question. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-26 : 22:32:12
|
| Are you doing something stupid like saving it to a text file in OEM format? Otherwise, it should work fine. I just tested both unicode and non-unicode data going to both ANSI and UNICODE formats. All the exports worked fine. I also tested saving the results of QA to a .rpt file.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
Posted - 2005-04-27 : 11:10:55
|
| I am doing it something like this:UPDATE tblLettersSET Content = '" & Me.RichTextBoxPrintCtrl1.Rtf & "'WHERE LetterID = '" & Me.cbLetters.Text & "'Should I not use .RTF?BrendaIf it weren't for you guys, where would I be? |
|
|
|
|
|
|
|
|
Spanich Accents...not working.