1

SQLServer : Problem in inserting Arabic data using ntext datatype

by Syed Aziz ur Rahman 8. March 2006 01:03

Have you ever tried to insert arabic data using ntext data type in SQL Server2000? I am sure you had. Did you face any strange problems? I had. It was a dotnet based desktop application. The strange problem was: If I insert english data, it comes back fine but if I insert arabic data, it gets corrupted. Strange, we were doing this in our web based news portal site and it is working fine there.

 

Then I dig into the problem. I came to know that if the data is smaller in size, it goes back and forth properly. But if it is a little bit bigger it gets corrupted. That was just heuristically tested. I figured that data bigger than 4000 char is making the problem. I checked the documentation but there is nothing there.

I consulted the guys responsible for news portal website. I asked them whether they are doing something special. Why they are not having this problem. Finally they reported that they encrypt the article contents before putting it in the database for security reasons and decrypting before displaying on the website.

They forwarded me the Encrypt/Decrypt class. I used the same technique and WALLAAAAA.... it worked. Now I can insert records bigger than 6000 and it is coming back just fine.

Cannot figure out the problem, unable to figure the solution as well. Just used CP technology (Copy Paste Technology) to solve the problem. I will dig into it more when I get some time. If you ever encountered such problem, please comment.

Tags:

SqlServer

Comments (1) -

khurram
khurram
3/9/2006 3:46:20 AM #

Have you tried using different collations?

www.umachandar.com/.../Main10.htm">www.umachandar.com/.../Main10.htm

Finance course online
Finance course online
8/20/2013 3:30:09 AM #

If you wish for to take a great deal from this article then you have to apply such techniques to your won blog.

Have a look at my web page  Finance course online - http://mycashtown.com/

argumentompharma.com
argumentompharma.com
8/22/2013 10:49:40 PM #

Hey! Quick question that's totally off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my iphone. I'm trying to find a theme or plugin that might be able to fix this problem. If you have any recommendations, please share. Thank you!

my website - La hiperplasia benigna de prostata ( argumentompharma.com - argumentompharma.com/.../ )

Cecilia
Cecilia
8/23/2013 1:41:20 AM #

I loved as much as you will receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an impatience over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this increase.

Look at my page novoline welches spiel ist am besten;  Cecilia - http://yuyu.vn/blog/246108// ,

Marisa
Marisa
9/17/2013 4:21:18 AM #

Apr, could be the amount of interest how the enterprise prices over the bank loan while you are how to pay it back. Though payday advances can be quick and additionally effortless examine their particular APRs along with the RATE OF INTEREST.

Here is my page - home ( Marisa - http://cancanit.com/www/www.ajuegosa.es/ )

Gain Lean Muscle Mass
Gain Lean Muscle Mass
10/3/2013 8:23:42 AM #

Normally I don't read article on blogs, but I wish to say that this write-up very compelled me to try and do so! Your writing taste has been surprised me. Thanks, quite nice article.

Also visit my web-site  Gain Lean Muscle Mass - life-coaching-blog.de/index.php?title=Benutzer:NormanMurphy

business landline phone systems
business landline phone systems
10/12/2013 6:53:27 PM #

Great post. I was checking continuously this blog and I am impressed! Very helpful info particularly the last part Smile I care for such info much. I was seeking this certain information for a very long time. Thank you and best of luck.

Also visit my site -  business landline phone systems - pustaka7.ristek.go.id/.../Creating_Inexpensive_Phone_Calls_To_Pakistan_With_Voip

Pldt Landline Plus Wireless Phone
Pldt Landline Plus Wireless Phone
10/15/2013 10:01:12 AM #

Since the admin of this web page is working, no uncertainty very shortly it will be well-known, due to its feature contents.

my homepage:  Pldt Landline Plus Wireless Phone - 198.23.143.205/.../

What Men Secretly Want Reviews
What Men Secretly Want Reviews
10/30/2013 8:27:10 AM #

Greetings! Very useful advice in this particular article! It is the little changes which will make the biggest changes. Thanks for sharing!

Here is my homepage:  What Men Secretly Want Reviews - http://www.WhatMenSecretlyWantReview.org/

Does 21 Day Sugar Detox Really Work
Does 21 Day Sugar Detox Really Work
10/31/2013 9:21:13 PM #

Wonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! Thank you

Here is my web page:  Does 21 Day Sugar Detox Really Work - http://21daysugardetoxreview.blogspot.com/

Dean
Dean
11/11/2013 4:11:35 PM #

This is the perfect webpage for anybody who really wants to find out about this topic. You know a whole lot its almost tough to argue with you (not that I actually would want to…HaHa). You certainly put a new spin on a subject which has been discussed for years. Excellent stuff, just great!

Here is my site - Capture His Heart,  Dean - http://capture-his-heart-review.tumblr.com ,

Gemma
Gemma
11/18/2013 7:57:23 AM #

Auch bei jener Milchwirtschaft kommt ein weiteres spezifisches Problem hinzu: Im Lauf der Hugo Cocktail Hugo Sekt kette wird auch nämlich Milch unterschiedlicher Herkunft stets wieder vermischt. Corder ausfindig gemacht hat, findet sich in Italien wieder. Es gibt wirklich zahlreiche Hugo Sekt Hugo Sekt , die keine sowie nur wenige Hugo Sekt  hatten.

Also visit my page - sekt lagerung ( Gemma - webserver4.balt.net/phpinfo.php )

free itunes gift card codes 2013
free itunes gift card codes 2013
11/24/2013 9:04:47 AM #

It's awesome in favor of me to have a web site, which is beneficial for my know-how. thanks admin

Feel free to surf to my page -  free itunes gift card codes 2013 - http://wiki.doktormike.net/index.php/BenutzerTonghillipp9131

computer comparison
computer comparison
11/24/2013 9:11:52 PM #

However owing with the modern designs there's a simple complicated design within the system as properly. Mouse - pointing product that detects two-dimensional movement to the surface. RAM memory is lost when shutting-down the computer, unlike storage memory.

Here is my web site  computer comparison - mla.mrooms.org/.../view.php?id=545199&course=1

Powered by BlogEngine.NET 2.5.0.6
Original Design by Laptop Geek, Adapted by onesoft