| T O P I C R E V I E W |
| sergeda |
Posted - 27 Sep 2006 : 06:38:26
There is a problem with finding non-english movies. When I run script to find description, program sends to script movie title in unreadable form. So, script find nothing. I can see this in result window, where are some simbols instead of movie title. I have all the right settings in regional option in Windows and have Windows XP. It look like program was developed in earlier version of Windows because Windows XP uses unicode by-default. I had no problem with old 4.8 version of program. But I converted my base to new format and deleted old base eventually :( |
| 20 L A T E S T R E P L I E S (Newest First) |
| redshoe |
Posted - 18 Aug 2012 : 11:32:25
Is this bug resolved?
I have the same problem only this time it is hebrew |
| Custler |
Posted - 06 Dec 2008 : 09:30:04
Any news? |
| Custler |
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 |
Posted - 15 Jun 2007 : 11:32:08
Dear Alessio!
Have you any progress in this problem? |
| micron |
Posted - 01 May 2007 : 00:00:05
Alessio, any chance to get this sorted in foreseeable future...? |
| micron |
Posted - 04 Mar 2007 : 22:15:57
Alessio, any luck? Do you still need the help of community? |
| Alessio Viti |
Posted - 09 Jan 2007 : 23:22:58
Thank you Nikita for the screenshot.
I hope to be near to solve the problem...
Alessio |
| Nikita |
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 |
| Custler |
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).
|
| Custler |
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.
|
| Custler |
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. |
| Biero |
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 :) |
| Alessio Viti |
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 |
| sergeda |
Posted - 13 Dec 2006 : 15:20:42
I'm also ready to help. |
| Custler |
Posted - 13 Dec 2006 : 10:55:09
I am ready to help too.
|
| micron |
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
|
| Alessio Viti |
Posted - 12 Dec 2006 : 22:50:40
I am sorry, I haven't find a way yet... 
Alessio |
| sergeda |
Posted - 12 Dec 2006 : 16:06:20
The bug is still in 5.6.3 
Thanks |
| micron |
Posted - 28 Nov 2006 : 22:08:11
... and here http://www.binaryworks.it/forum/topic.asp?TOPIC_ID=2152 as well :)
|
| Custler |
Posted - 24 Nov 2006 : 21:50:41
I just want to remind you.
This bug was discussed in this topics also:
http://www.binaryworks.it/forum/topic.asp?TOPIC_ID=1764
http://www.binaryworks.it/forum/topic.asp?TOPIC_ID=1673 |
