473,322 Members | 1,781 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access: getting chinese (?) character unexpectedly, why?

In a report in Access (11.65566.8821 SP2) I receive what appears to be
Chinese characters for one field only. I can't find the setting that
made that happen, I'd like to return that field to English. Anyone
know? Thank you.
Oct 28 '08 #1
2 45369
Is it a memo field? Or a concatenated query field?

Causes include:
a) You group by a memo field in a query that has a join on an unindexed
field:
http://allenbrowne.com/bug-18.html

b) There is a corruption on the table\:
http://allenbrowne.com/ser-47.html#M...angeCharacters

c) You create a query where Access does not understand the data type
correctly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tintin" <E-**********@neiu.eduwrote in message
news:6d**********************************@p39g2000 hsb.googlegroups.com...
In a report in Access (11.65566.8821 SP2) I receive what appears to be
Chinese characters for one field only. I can't find the setting that
made that happen, I'd like to return that field to English. Anyone
know? Thank you.
Oct 28 '08 #2
Hello! No it was not concatenated query but yes it was a memo field,
displying as a Chinese-looking character followed by a box (or just a
box if there was no value in that field). I tried changing Group By
to First, as your page recommended, but then Access required me to
enter a value for that field before viewing the report. But I changed
Memo to Text as field type and the problem is solved. Thanks for
pointing me in the right direction, I would not have found that.
Tintin

On Oct 28, 9:05*am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Is it a memo field? Or a concatenated query field?

Causes include:
a) You group by a memo field in a query that has a join on an unindexed
field:
* * * *http://allenbrowne.com/bug-18.html

b) There is a corruption on the table\:
* * * *http://allenbrowne.com/ser-47.html#M...angeCharacters

c) You create a query whereAccessdoes not understand the data type
correctly.
Oct 30 '08 #3

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

Similar topics

4
by: see_mun_lee | last post by:
I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). <META...
0
by: boonkit | last post by:
Currently i store the chinese character in unicode decimal format (&#<number>;). In this way, I can display and search the chinese character correctly. However, this will take more storage space....
8
by: Agnes | last post by:
In my .net ,i need to generate an xml file , however, user may input a chinese character, Then , the xml will got something unknow characters. the following is my code, Does anyone know how to...
4
by: Winnie | last post by:
Hi, I am currently writing a C# Windows Application. On my form, I have several labels with Traditional Chinese text, it is ok on my machine (Windows 2000), but after install on Windows 98 or NT,...
0
by: Alex Chan | last post by:
Hi group, I am writing a RFC Server with SAP.NET Connector to connect to SAP. There are chinese characters passing back and forth. I found that all chinese characters sending from SAP are...
3
by: Spider_Jia | last post by:
I am using win 2000 and vstudio.net 2002. When I input chinese character into vb.net (aspx page) using vstudio.net, everything is okay.I can see the chinese words. But if i try to view it as a...
1
by: stepby | last post by:
Hi All, I have use the ajax with the server side language ASP. I find the when passing the parameter with the chinese character, the chinese character cannot show orderly and become "wrong code" ....
1
by: James Su | last post by:
I tried to use pymssql to access MSSQL 2000, with a table, I store Chinese Character in NVarchar field, Chinese Character display normally when I query them by MS SQL Query Analyzer under Windows...
5
by: qiqinuinaifen128 | last post by:
Hi Pros, I have a question regarding handling chinese character. I have an text area for user to key in sth. But when the user key in Chinese Character and click a button. The problem is when...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.