| Author |
 Topic  |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
 Posted - 12 Dec 2006 : 22:50:40
|
I am sorry, I haven't find a way yet... 
Alessio |
 |
|
|
micron
Starting Member
22 Posts |
Posted - 13 Dec 2006 : 00:27:14
|
No problem Alessio, we will wait as much as needed. You do the great job and develop the product at lightning speed which is not common these days!
Speaking on topic, perhaps this problem can be solved doing some research on general info on code pages or something..? I mean if you just need some time to gather information on certain Windows or .Net or programming topics - perhaps we could help and dig what you need and save you the time..? If this is the case I'm the first in line to help, just tell what to do! :)
Thank you so much again,
micron
|
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 13 Dec 2006 : 10:55:09
|
I am ready to help too.
|
|
|
|
sergeda
Starting Member
11 Posts |
Posted - 13 Dec 2006 : 15:20:42
|
| I'm also ready to help. |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 13 Dec 2006 : 21:33:58
|
Sorry guys to answer you so late.
I appreciate very much your help, I will write better how you can help me in next days.
Thank you again for all.
Alessio |
|
|
|
Biero
Starting Member
Russia
1 Posts |
Posted - 14 Dec 2006 : 21:40:20
|
| Not question, not reminder, just a comment: I have the same problem :( Request to WEB comes in wrong charset. Russia :) |
Edited by - Biero on 14 Dec 2006 21:41:55 |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 14 Dec 2006 : 22:41:31
|
I think the problem comes from the method of storing text data in .mdb database.
All text in Msaccess database are stored in Unicode.
=======Quote:====
Microsoft Access 2000 or later uses the Unicode (Unicode: A character encoding standard developed by the Unicode Consortium. By using more than one byte to represent each character, Unicode enables almost all of the written languages in the world to be represented by using a single character set.) character-encoding scheme to represent the data in a Text (Text data type: In a Microsoft Access database, this is a field data type. Text fields can contain up to 255 characters or the number of characters specified by the FieldSize property, whichever is less.), Memo (Memo data type: In a Microsoft Access database, this is a field data type. Memo fields can contain up to 65,535 characters.), or Hyperlink (Hyperlink data type: A data type for an Access database field that stores hyperlink addresses. An address can have up to four parts and is written using the following format: displaytext#address#subaddress#.) field. Unicode represents each character as two bytes, so the data in a Text, Memo, or Hyperlink field requires more storage space than it did in Access 97 or earlier, where each character is represented as one byte.
To offset this effect of Unicode character representation and to ensure optimal performance, the default value of the Unicode Compression property for a Text, Memo, or Hyperlink field is Yes. When a field's Unicode Compression property is set to Yes, any character whose first byte is 0 is compressed when it is stored and uncompressed when it is retrieved. Because the first byte of a Latin character— a character of a Western European language such as English, Spanish, or German— is 0, Unicode character representation does not affect how much storage space is required for compressed data that consists entirely of Latin characters.
In a single field, you can store any combination of characters that Unicode supports. However, if the first byte of a particular character is not 0, that character is not compressed.
============
So, if you take text from Text field, it can be one byte per symbol (for US-English) or two bytes per symbol (for national character).
For example:
Russian letter #1044; (Di) - 0xC4 in 1251 codepage, stored in .mdb as 0x0414 in Unicode.
And if you simply take this code from database Text field and insert it to webquery, you will receive unpredictable result.
For movie "Dogma" (#1044;#1086;#1075;#1084;#1072; - in russian):
Dogma - stored in database as (in hex): 44 6F 67 6D 61
#1044;#1086;#1075;#1084;#1072; - stored as (in hex) 14 04 3E 04 33 04 3C 04 30 04
And in last case you receive in webquery 10 unprintable character instead of 5. |
Edited by - Custler on 14 Dec 2006 22:55:02 |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 14 Dec 2006 : 22:43:18
|
As I can see, your forum has exactly the same problem. 
I type russian letter in post above, but it shows #1044 instead.
#1044 (in decimal) = 0x414.
IMHO, you need to use other method to get text from database Text field.
In both case - in the program and in the forum.
|
Edited by - Custler on 14 Dec 2006 22:53:44 |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 15 Dec 2006 : 10:16:59
|
Dear Alessio!
I can try to solve this problem, but I need a small part of your code where you connect to database (open database), and part of code where you get data from "Title" Text field from "Movies" table.
You can send it to me by mail (svt "AT" id "DOT" ru).
|
Edited by - Custler on 15 Dec 2006 10:20:09 |
|
|
|
Nikita
Starting Member
Russia
10 Posts |
Posted - 09 Jan 2007 : 16:04:44
|
quote:
Originally posted by Alessio Viti
Hi,
Can I ask you to send here (or by email) a screenshot? So I can better see the problem 
Thank you!
Alessio
I can make screenshot of this problem, where
(1) is current searched title in cyrrilic - OK
(2) is correct cyrillic title in "eXtreme download monitor G3 window" - OK
(3) is result of search by title - - NOT OK
http://img13.imagevenue.com/img.php?image=51287_Internet_search_122_420lo.jpg
PS sorry for my terrible english |
Edited by - Nikita on 09 Jan 2007 16:12:54 |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 09 Jan 2007 : 23:22:58
|
Thank you Nikita for the screenshot.
I hope to be near to solve the problem...
Alessio |
|
|
|
micron
Starting Member
22 Posts |
Posted - 04 Mar 2007 : 22:15:57
|
| Alessio, any luck? Do you still need the help of community? |
|
|
|
micron
Starting Member
22 Posts |
Posted - 01 May 2007 : 00:00:05
|
| Alessio, any chance to get this sorted in foreseeable future...? |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 15 Jun 2007 : 11:32:08
|
Dear Alessio!
Have you any progress in this problem? |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 22 Nov 2008 : 14:32:16
|
Dear Alessio!
I would like just to reminde you that this problem still exist in last version (6.5.1.0).
Is any progrees in this direction? |
|
|
|
Custler
Starting Member
Russia
44 Posts |
Posted - 06 Dec 2008 : 09:30:04
|
| Any news? |
|
|
|
redshoe
Starting Member
4 Posts |
Posted - 18 Aug 2012 : 11:32:25
|
Is this bug resolved?
I have the same problem only this time it is hebrew |
|
|
|
Topic |
|
|
Problem with non-english movie titles and finding