473,725 Members | 2,169 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Code page translations are not supported for the text data type. From: 1252 To: 950.

Code page translations are not supported for the text data type. From:
1252 To: 950.

I would like to know what this message means. I also installed the
language packs in advanced settings, Everything is set to English. My
windows XP computer is XP English. For some reason I cant get an update
to go thru using ADO. like Recordset.Updat e

Although other routines using .update work

Any ideas?

Jul 23 '05 #1
6 5124
Is it possible that If I installed MSDE when I had set under advanced
settings the nonunicode programs to Chinese that this would happen? I
have also noticed I can get around this by using the N' like select *
from some where something = N'something'

Anyway, how does one normally get around this issue, would an uninstall
of MSDE and then reinstall while XP is set to English fix this issue?

Jul 23 '05 #2
That worked, uninstaled MSDE and reinstalled while XP was set to
english.
But I think the only setting change I made was under
control panel
regional settings
advanced language for nonunicode programs to Chinese(Taiwan) .

Jul 23 '05 #3
Hi

The collation was probably not explicitly set for the installation see
http://msdn.microsoft.com/library/de...stsql_84xl.asp
http://msdn.microsoft.com/library/de...ca-co_2e95.asp

John
<sd********@msn .com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
That worked, uninstaled MSDE and reinstalled while XP was set to
english.
But I think the only setting change I made was under
control panel
regional settings
advanced language for nonunicode programs to Chinese(Taiwan) .

Jul 23 '05 #4
Yes, it gives no options on the install, it must just use whatever is
set for the language. That does answer another question I was wondering
about, involving default collations. Is there an updated install for
MSDE, I only have the one off my Office XP CDROM. from 2000

Jul 23 '05 #5
Hi

The latest release is downloadable from
http://www.microsoft.com/downloads/d...displaylang=en
this includes SP3a although you can apply SP3a to your existing system using
the appropriate download from
http://www.microsoft.com/sql/downloads/2000/sp3.asp

John

<sd********@msn .com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
Yes, it gives no options on the install, it must just use whatever is
set for the language. That does answer another question I was wondering
about, involving default collations. Is there an updated install for
MSDE, I only have the one off my Office XP CDROM. from 2000

Jul 23 '05 #6
sd********@msn. com (sd********@msn .com) writes:
Is it possible that If I installed MSDE when I had set under advanced
settings the nonunicode programs to Chinese that this would happen? I
have also noticed I can get around this by using the N' like select *
from some where something = N'something'


The N' means that the literal is nvarchar and thus Unicode, and thus not
subject to conversion between different 8-bit character sets.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
4362
by: David Girard | last post by:
I'm getting the following error which is no big deal - the problem is it is LOCATION specific - which has me really baffled... for some reason the error only appears on different machines in different various locations. I've checked the versions of browsers and I've tried from at least 10 different pc's in different locations and the page comes up perfect. My web server is up to date with all current patches. Occasionally, someone will...
0
1382
by: b | last post by:
When I create chm with docbook I have most of the pages on one file. So, when I search for "Linux" page begins with "Sample HTML" .... I get the page with several pages in one. Can this be avoided? Can every page (copyright, disclaimer, credits) be on separate pages? Also when viewing chm "Sample xml" text is in the same page as "introduction", "copyright" ... here is xml: Sample-HOWTO.xml
14
1692
by: Ian Richardson | last post by:
I'm writing a large Javascript application (uncompressed source around 400K) which is doing almost all the initialisation it needs to in a just-in-time manner. However, I have included an option for almost all of this to be done when the application first starts. Under this circumstance, and since the last few nightly builds of Mozilla, I've been getting: Script warning:
2
2376
by: rked | last post by:
I get nameSPAN1 is undefined when I place cursor in comments box.. <%@ LANGUAGE="VBScript" %> <% DIM ipAddress ipAddress=Request.Servervariables("REMOTE_HOST") %> <html> <head> <meta http-equiv="Content-Type" content="text/html;
17
2644
by: Paul | last post by:
HI! I get an error with this code. <SCRIPT language="JavaScript"> If (ifp==""){ ifp="default.htm"} //--></SCRIPT> Basicly I want my iframe to have a default page if the user enters in directly. so I need a way doing this. so I check to see if the ifp value is null and if so then assign it a value. is this correct?
2
1955
by: David Scemama | last post by:
Hi, I'm developing an application that reads data from a file. The data has been encoded using code page 850. I use the FileOpen function to open the file and the FileGet function to read the records, but the string I read is encoded using code page 1252. Is there a way to specify the codepage before reading the data, or do I have to convert every string I find ? I've found a sample of convertion function in the help, but it slows...
3
12014
by: nan | last post by:
Hi All, I am trying to connect the Database which is installed in AS400 using DB2 Client Version 8 in Windows box. First i created the Catalog, then when i selected the connection type as ODBC, then i am getting
5
12306
by: Neil Rossi | last post by:
I have an issue with a particular ASP page on two web servers. Let's call these servers Dev1 and Beta1. Both Servers are running IIS 5, Windows 2000 SP4 with "almost" all of the latest patches. On Beta1, I am able to execute a particular page with no problem, that page opens up in the comes up just fine. On Win2kdev1, when I go to execute the same page, it opens a file download dialog and asks me whether I want to open or save the...
0
1528
by: sanjaygupta11 | last post by:
I am using httpwebrequest and httpwebresponse objects for sending data to remote appication by post and receiving the response from there. I am using this code in my windows application which will send a request to remote application. --------------------------------------------------------------------------------------------------------------- string lcUrl = "http://localhost/check/WebSite3/Default.aspx"; HttpWebRequest loHttp...
0
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9257
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9176
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9113
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6011
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4784
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3221
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2635
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2157
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.