December 23, 2011 at 5:48 am
Dear All,
When data is saved from one of our application, it doesn't get saved in its actual format.
Instead it's saved as something else.
For example, the actual data is something like "搜狗高速浏览器" (not exactly same).
But it's saved as "ѹËõÎļþ¹ÜÀíÆ÷". Why is this happening ?
Data type of the field is "NVarchar".
We are confused because, not all the records are having problem.
There are many records with, Japanese/Chines/Korean etc; charecters, saved in its original format.
Issue is only with some of the records.
While selecting the data, is it possible to get it in the correct format ?
What's the solution/workaround for this problem ?.
Thanks in advance.
December 23, 2011 at 6:12 am
It might not appear in the same format in SSMS but when you pull it back in application with proper regional font, does it appear correctly there?
December 23, 2011 at 6:51 am
..Thanks for the quick response.
No way to check. It's a third party application. We dont have any option to verify it.
Why this issue only for few records. ? Could this be with only few client PCs?
If so, Whats the solution ?
Thanks a lot again.
December 23, 2011 at 7:10 am
I worked on Multi-Lingual databases and honestly speaking I never bothered to verify it in SSMS. First reason for that was I didn’t know the language :hehe:. Second reason, SSMS shows special letters in the weird format (e.g. rectangular box for newline character in plain English). Luckily it was company’s proprietary database (product based) and Front End was available for us to verify the same.
I am afraid I can’t help you more on your questions.
December 26, 2011 at 2:40 am
Can anyone shed some light on this please ?
Thanks.
December 26, 2011 at 8:23 am
Its festival time & most of the members are on vacation. Please have patience. They will revert to you soon.
December 27, 2011 at 6:00 am
How are you 'viewing' the saved data? It's possible its saved perfectly but your viewer doesn't support the characters you need.
You might want to be more specific - how is it actually saved? (binary file, Excel document, database), and then what is that loaded into to view it?
December 27, 2011 at 7:21 am
You could try exporting into a csv file and then view it. SSMS is not the tool to check if the languages are saved good.
You can check if the language you are checking is supported by SQL Server. You can check sys.syslanguages to see if the language exists.
-Roy
December 27, 2011 at 7:29 am
I would tend to suspect the application code far more than the database. NVarchar is just fine with extended character sets.
Another possibility is user-input issues. Is your application public-facing, or purely internal?
I periodically get a few rows of garbage data, similar to what you're seeing, coming from bots that are being used to probe our websites for security holes. Hackers, script kiddies, et al, will populate garbage data into a field to see if they can get a buffer-overflow exploit going, or for SQL injection attempts. If the application is public facing, is that a possibility you've eliminated from you list of potential causes?
- 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
December 27, 2011 at 7:38 am
Hi All,
Thanks for the responses. It's a third party application.
I believe the issue is with client PCs. Because there are data from many other PCs in the proper format, like chinese, japanese and all.
If you ask me how the data is sent to DB, I dont have any clue actually.
I am almost sure that the data which sent from client to DB itself is in wrong format.
I dont what I will have to do on client PCs to get it in suitable format to DB.
Once again, thanks a million.
Smith.
December 27, 2011 at 8:25 am
The client pcs could certainly be an issue. Could also be browser version issues, if the application is browser-based. Or could be a WINE vs Windows issue, if it's a thick client being run in an emulator instead of in Windows itself, or something like that.
Lots of possibilities. Can't really narrow it down without further information.
Is it a public-facing application?
Is it browser-based (thin or "semi-thick" client)?
Is it a thick-client application (.NET, JAVA, C, or something similar)?
What browsers (IE, Firefox, Chrome, Opera, et al) is it compatible with, if applicable? What versions has it been tested in?
Start from there.
- 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
December 28, 2011 at 12:07 am
Is it a public-facing application? ==> No
Is it browser-based (thin or "semi-thick" client)? ==> No
Is it a thick-client application (.NET, JAVA, C, or something similar)? ==> .Net App, Runs as service.
What browsers (IE, Firefox, Chrome, Opera, et al) is it compatible with, if applicable?
What versions has it been tested in? ==> It works fine on more than a hundred thousand PCs. Problem is only with very few PCs (less than 500).. mainly in China.
Thanks.
December 28, 2011 at 6:45 am
In that case, it's going to be some setting or O/S incompatibility. Windows versions that are out-of-date, that kind of thing, is where I'd start looking. China is the software piracy capital of the universe, so pirate copies of Windows, which can't be patched through the normal process, would definitely be worth checking for.
- 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
December 28, 2011 at 6:48 am
GSquared (12/28/2011)
In that case, it's going to be some setting or O/S incompatibility. Windows versions that are out-of-date, that kind of thing, is where I'd start looking. China is the software piracy capital of the universe, so pirate copies of Windows, which can't be patched through the normal process, would definitely be worth checking for.
I didn’t read it 😀
December 28, 2011 at 7:39 am
Thank you somuch. Infact we found some descrepencies in the OS language settings with the PCs that are not proper. We are focusing more on that area.
Thanks a ton again.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply