Collation

rcd.guerra · October 25, 2011 7:33AM

Hello,

my SQL Server db has correct collation "Latin1_General_CI_AS".

If i update some varchar column with the value "ComitÃ©" for instance it is commited correctly.

When i'm generating data from the tool, it is complying with the db collation.

For instance, the value "ComitÃ©" is inserted as "Comit�".

Does anyone have a clue why this is happening ?

Thanks in advance!

Best regards,
Ricardo

Eddie D · October 26, 2011 1:03PM

Thank you for your post into the forum and sorry that you have encountered a problem.

What collation is the database configured to use?

If different, what is the collation of this particular varchar column?

What Windows language setting and keyboard layout are you using?

Many Thanks
Eddie

rcd.guerra · November 9, 2011 10:33AM

Hi Eddie,

thanks for your post.

The db and particular column use the same collation, Latin1_General_CI_AS.

Windows Language is en-US.

Default input language is pt-PT (Portuguese).

Keyboard layout is en-US

Thanks for your time.

James B · November 14, 2011 9:42AM

Thanks for coming back to us.

I've just set up a DB using that collation and used Data Generator to insert "ComitÃ©" into a varchar(50) column. It seemed to work correctly (querying the table in SSMS shows the value correctly).

Could you tell us a little more about what generator you are using for that column, how you're specifying the values and so on?

rcd.guerra · November 17, 2011 11:41AM

Hi, thanks for your post.

We are using a FileList generator having a file containing a set of values with accents.

I've tried changing that file encoding but no success either.

rcd.guerra · November 17, 2011 11:50AM

We've also tried running Data Generator against another db server and database but with the same result.

Can you explain how does the generator fills the values in the preview so we can also debug what might be wrong here ?

Thanks a lot!

Ricardo

James B · November 17, 2011 12:02PM

Is it possible for you to mail the file you're using to support@red-gate.com with F0053639 as a subject line? I'd like to try it myself. I've seen something similar before and I'm fairly sure it was the file encoding, but if I can test it out myself I can be sure.

rcd.guerra · November 18, 2011 6:33AM

James, just sent the email.

Thanks a lot!

James B · November 21, 2011 3:48PM

In case anyone else runs into this, the solution was to open the file containing the text list to be used with SQL Data Generator in Notepad, and then go to File > Save As.

Ensure "UTF-8" is selected as the file type, then save it.

Collation

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk