Hi,
Our school has an application in which :
- Teachers enter comments through a web interface built in asp (not
asp.net).
- Comments are stored in a SQL server 2000 (in a nText field)
- Comments are printed through a MS-Access 2002 front-end...
Most comments are in English, Spanish or French. Some comments are
English + Japanese.
- The Japanese teachers can enter their comments through the web
interface without any glitch.
- The comments are obviously stored properly in the nText field, as
they can be displayed through the web interface.
Here is where problems start to occur...
- When browsing through the table using the Enterprise Manager, the
comment appears blank if it contains some Japanese.
- When browsing through the table in Access (the table being linked),
we can see the series of unicodes :
漢字テス... while, in the next paragraph, the
English text is perfectly readable...
- Similarly, on the printed report, the Japanese text appears as a
series of Unicodes, while the English text appears perfactly readable.
If I copy the Japanese text from the web interface and paste it into
the linked table in Access, it displays perfectly and prints perfectly
in Access. But of course, I can't do that manually for all students...
However, if I now look at the same record through the Enterprise
Manager, I see the text (at last !) but only as a series of unreadable
characters. I can imagine that that last problem is due to a lack of
Japanese font in the Enterprise Manager, bacause if I copy these
uneradable characters and paste them in the original web form, they
display perfectly...
I would really appreciate if someone could help me sort out that
problem.
Many thanks for all ideas.
DL
4  5854 
DL (la*****@isb.be ) writes:
- When browsing through the table using the Enterprise Manager, the
comment appears blank if it contains some Japanese.
What do you see in Query Analyzer?
- When browsing through the table in Access (the table being linked),
we can see the series of unicodes :
漢字テス... while, in the next paragraph, the
English text is perfectly readable...
Do you actually see the ampersand, hash mark, digits and semicolon?
In such case, I would assume that the page writes that do the database.
The browser will present those codes correctly, but obviously Access
will not.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
On Feb 21, 11:58 pm, Erland Sommarskog <esq...@sommars kog.sewrote:
DL (lalo...@isb.be ) writes:
- When browsing through the table using the Enterprise Manager, the
comment appears blank if it contains some Japanese.
What do you see in Query Analyzer?
- When browsing through the table in Access (the table being linked),
we can see the series of unicodes :
漢字テス... while, in the next paragraph, the
English text is perfectly readable...
Do you actually see the ampersand, hash mark, digits and semicolon?
In such case, I would assume that the page writes that do the database.
The browser will present those codes correctly, but obviously Access
will not.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx
Hi Erland,
Yes. I see the ampersand, hash mark, digits and semicolon.
That's actually a good point. It would mean that the problem is with
the communication between the asp pages and the sql server : asp that
would let the user type Japanese characters in the text control, but
the typed text would be translated into the sequence of ampersand,
hash mark, digits and semicolon...
That would also explain what I discovered after having posted my
message : I went back to similar data that was entered in an Access
database last year and years before, using Access as a front-end. The
Japanese text always printed properly and was never a problem. I
transfered it to the sql server and looked at it through the new web
interface : it displayed as series of question marks (?????80%????.. .)
Do you by chance know how I could eliminate that problem linked to the
web interface or do you suggest I post the question on an asp list ?
Thanks for helping me clarify the source of my problem,
DL
On Feb 21, 11:58 pm, Erland Sommarskog <esq...@sommars kog.sewrote:
DL (lalo...@isb.be ) writes:
- When browsing through the table using the Enterprise Manager, the
comment appears blank if it contains some Japanese.
What do you see in Query Analyzer?
- When browsing through the table in Access (the table being linked),
we can see the series of unicodes :
漢字テス... while, in the next paragraph, the
English text is perfectly readable...
Do you actually see the ampersand, hash mark, digits and semicolon?
In such case, I would assume that the page writes that do the database.
The browser will present those codes correctly, but obviously Access
will not.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Auric__ |
last post by:
I need to copy some Unicode text to the Clipboard, but it ain't
happening. :/
If there's no equivalent in VB, what's the API call?
--
auric "underscore" "underscore" "at" hotmail "dot" com
*****
The truth depends on, or is only arrived at by, a legitimate deduction from all the facts which are truly material. Whispering tongues can poison truth.
-- Coleridge
|
by: Eric Brunel |
last post by:
Hi all,
I'm in the process of localizing a Tkinter application and I'm struggling with a
problem for which I can't figure out a solution. The following code:
-------------------------------
from Tkinter import *
root = Tk()
root.tk.call('encoding', 'system', 'utf-8')
|
by: Avnish |
last post by:
Hi,
I am looking for some form of validation for all the alphanumeric
characters in the entire unicode range e.g. the validation should also
accept japanese characters but should restrict japanese punctuation
marks. I need this validation for atleast for the CJKT range if not
possible for the entire unicode range. I can even make use of regular
expressions.
Also, please note that this validation should be in Javascript
|
by: Zenobia |
last post by:
Recently I was editing a document in GoLive 6. I like GoLive because it has some nice
features such as:
* rewrite source code
* check syntax
* global search & replace (through several files at once)
* regular expression search & replace.
Normally my documents are encoded with the ISO setting.
Recently I was writing an XHTML document. After changing the encoding to UTF-8 I used the
|
by: hunterb |
last post by:
I have a file which has no BOM and contains mostly single byte chars. There
are numerous double byte chars (Japanese) which appear throughout. I need to
take the resulting Unicode and store it in a DB and display it onscreen. No
matter which way I open the file, convert it to Unicode/leave it as is or
what ever, I see all single bytes ok, but double bytes become 2 seperate
single bytes. Surely there is an easy way to convert these mixed...
| | |
by: apprentice |
last post by:
Hello,
I'm writing an class library that I imagine people from different countries
might be interested in using, so I'm considering what needs to be provided
to support foreign languages, including asian languages (chinese, japanese,
korean, etc).
First of all, strings will be passed to my class methods, some of which
based on the language (and on the encoding) might contain characters that
require more that a single byte.
|
by: ujjwaltrivedi |
last post by:
Hey guys,
Can anyone tell me how to create a text file with Unicode Encoding. In
am using
FileStream Finalfile = new FileStream("finalfile.txt",
FileMode.Append, FileAccess.Write);
###Question:
Now this creates finalfile.txt with ANSI Encoding ...which is a
default. Either tell me how to change the default or how to create a
|
by: shorti |
last post by:
Hello, I am running DB2 UDB 8.2 on AIX 5.3. I am running some tests
on converting several tables on an existing database to Unicode. The
database will not be converted to unicode...just this table set.
I have successfully set this up and ran some tests using Japanese
characters. The test seemed to work fine. We found during our test
that we needed to install some AIX UTF-8 software for the web-based
user interface to work properly. ...
|
by: mario |
last post by:
I have checks in code, to ensure a decode/encode cycle returns the
original string.
Given no UnicodeErrors, are there any cases for the following not to
be True?
unicode(s, enc).encode(enc) == s
mario
|
by: David |
last post by:
Hi list.
I've never used unicode in a Python script before, but I need to now.
I'm not sure where to start. I'm hoping that a kind soul can help me
out here.
My current (almost non-existant) knowledge of unicode:
string types. What I don't understand yet is what encodings are and
when you'd want/need to use them. What I'd like is to just be able to
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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...
|
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
| | |
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
|
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...
| |
