-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: Multi-language problem
PostPosted: Fri Dec 02, 2005 2:27 pm 
Newbie

Joined: Fri Dec 02, 2005 2:15 pm
Posts: 4
This isn't a Winforms problem per say, as I've noticed the same problem while trying in compile time.

I've created a new live object, and in one of its fields, i've set it to a word written in Hebrew. It was written in a Textbox control.
The object seems to stay in hebrew, but the entry in MySQL (my backend of choice, all fields set as unicode general insensitive) only shows ??????

After re-loading the application, the entry loads with ?????? all over where hebrew was supposed to be, reflecting the 'change' in MySQL.

I inserted a manual word in hebrew (using FireFox) and loaded the application, and everything showed fine.

Any ideas how I can fix this wacky (extremely problematic) behavior?

Here are images taken of the program, two entries: one inserted using the WinForms (and same behavior when I tried to add the word in compile time, using ""'s) and the other is being read after it was inserted using FireFox using phpmyAdmin.

Image
Image


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 02, 2005 2:32 pm 
Newbie

Joined: Fri Dec 02, 2005 2:15 pm
Posts: 4
Just wanted to note that the field types in MySQL are varchar...


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 05, 2005 2:18 pm 
Newbie

Joined: Fri Dec 02, 2005 2:15 pm
Posts: 4
Help, Please :-/ ?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 06, 2005 7:49 am 
Contributor
Contributor

Joined: Thu May 12, 2005 9:45 am
Posts: 593
Location: nhibernate.org
Can you change your log4net level to DEBUG and see how your query is converted to SQL? (mainly how the hebrew text is written)

_________________
Pierre Henri Kuaté.
Get NHibernate in Action Now!


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 07, 2005 5:22 am 
Newbie

Joined: Fri Dec 02, 2005 2:15 pm
Posts: 4
After looking for a solution, it turns out nHibernate is not the one to blame:

In case you run into a similar problem, here's what I did to fix it:

1) Install the latest Database software (upgrade) and make sure that you tag any multi-language aiding options.

2) Add globalization information to your config files (Google for "Globalization C#")

That solved the problem for me.
Sorry again for troubling the staff :-)


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.