Red Gate forums :: View topic - Collation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Collation

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rcd.guerra



Joined: 13 Sep 2010
Posts: 10

PostPosted: Tue Oct 25, 2011 12:33 pm    Post subject: Collation Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Wed Oct 26, 2011 6:03 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
rcd.guerra



Joined: 13 Sep 2010
Posts: 10

PostPosted: Wed Nov 09, 2011 4:33 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Nov 14, 2011 3:42 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
rcd.guerra



Joined: 13 Sep 2010
Posts: 10

PostPosted: Thu Nov 17, 2011 5:41 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
rcd.guerra



Joined: 13 Sep 2010
Posts: 10

PostPosted: Thu Nov 17, 2011 5:50 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu Nov 17, 2011 6:02 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
rcd.guerra



Joined: 13 Sep 2010
Posts: 10

PostPosted: Fri Nov 18, 2011 12:33 pm    Post subject: Reply with quote

James, just sent the email.

Thanks a lot!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Nov 21, 2011 9:48 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group