| |
DynamiCube Support
Started by voillequin jm at 07-22-2009 5:46 AM. Topic has 11 replies.
  
|
|
Sort Posts:
|
|
|
|
 07-22-2009, 5:46 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
Attachment: dd.doc
|
|
|
|
|
Hi,
I saw several posts in this forum that explain how to display unicode strings in a cube.
I think I have done everything, and the cube still not display Japanese strings correctly. I have done the same test case in a Korean environment, and the problem still occurs.
Please, see the attachment.
|
|
|
|
|
Report
|
|
|
|
|
07-22-2009, 7:47 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
Hello.
From the attached document I can see that you've set your system's language used by non-Unicode programs to the appropriate language (Japanese).
However, I think, you didn't set the Charset property to the appropriate character
Ex:
DCube1.FilteredFieldFont.Charset = 128
DCube1.FieldFont.Charset = 128
DCube1.HeadingsFont.Charset = 128
DCube1.TotalsFont.Charset = 128
DCube1.Font.Charset = 128
DCube1.HeaderFont.Charset = 128
Try to unclude this code snippet with your sample (SHIFTJIS (128) is Japanese charset).
The list below displays some of the different character sets available.
ANSI_CHARSET 0
DEFAULT_CHARSET 1
SYMBOL_CHARSET 2
SHIFTJIS_CHARSET 128
HANGEUL_CHARSET 129
HANGUL_CHARSET 129
GB2312_CHARSET 134
CHINESEBIG5_CHARSET 136
OEM_CHARSET 255
JOHAB_CHARSET 130
HEBREW_CHARSET 177
ARABIC_CHARSET 178
GREEK_CHARSET 161
TURKISH_CHARSET 162
VIETNAMESE_CHARSET 163
THAI_CHARSET 222
EASTEUROPE_CHARSET 238
RUSSIAN_CHARSET 204
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 1:22 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
Attachment: dd2.jpg
|
|
|
|
|
|
Hello,
No I dit it directly in the font selection window by selecting 'Japonais' as Script. Even by adding your piece of code in the form load event, the problem still occurs, as you can see in the attachment.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 2:39 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
voillequin,
Can you send me a sample (saved .cub file, for example) which shows issue so I can look into this? You can attach it to forum post as .zip file or send to DynamiCube.support@grapecity.us.com.
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 2:56 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
Attachment: jap.rar
|
|
|
|
|
|
|
|
|
07-23-2009, 4:19 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
Attachment: dcChinese.zip
|
|
|
|
|
|
voillequin,
After testing your .cub I am getting the same characters as you. Are you sure they are wrong? Also, can you try another Connection Type instead of ODBC? I've found one access database with chinese characters and they are displaying normally using ADO connection. Please see the attachment.
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 7:54 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
Your sample contains the following code:
Private Sub Form_Load()
'Database = App.Path & "\DCDEMOJP.MDB"
DCube1.DCConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
& App.Path & "\DCDEMOJP.MDB" & ";Persist Security
Info=False"
DCube1.FilteredFieldFont.Charset = 128
DCube1.FieldFont.Charset = 128
DCube1.HeadingsFont.Charset = 128
DCube1.TotalsFont.Charset = 128
DCube1.Font.Charset = 128
DCube1.HeaderFont.Charset = 128
End Sub
How can it work with Chinese strings width Charset=128 ? 128 is the charset for Japanese characters.
And I'm sure that characters displayed in the cube are wrong. In my first attachment, I sent you the string expected (in database), which is really different from the string displayed. I have done the same test (in Japanese) with an ADO connection, and the result is the same.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 8:17 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
voillequin,
Sorry, actually my attached sample is Japanese sample, I named it Chinese by mistake.
Can you please send me a database (or a small part of database) for testing?
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 10:37 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
It's a bit difficult. This is a huge Oracle database. I can send you some Japanese strings if you want to put them in your Access Database:
ビッド価格
ブロック日
列
For instance.
Hope it can help you to solve this critical situation for me !
|
|
|
|
|
Report
|
|
|
|
|
07-23-2009, 11:36 PM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
Attachment: dcJapanese.zip
|
|
|
|
|
|
voillequin jm,
I've put these Japanese strings into Access database and DynamiCube displays them normally. Please find the attached sample and screenshot.
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
07-24-2009, 6:47 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
Ok, it works also for me !
We have developped our own ADO Data Provider. And I saw that it was unable to extract Japanese strings from DB corretly.
Thank you for your help.
|
|
|
|
|
Report
|
|
|
|
|
07-27-2009, 5:19 AM
|
voillequin jm
Joined on 07-22-2009
Posts 7
|
Re: Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|
|
The problem comes from ADO provider supplied by Microsoft. It's not Unicode compliant. Using the ADO provided by Oracle (OraOLEDB.oracle) solves the problem.
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » DynamiCube Supp... » Unicode issue: unable to display Japanese characters in headings of a cube (SP 3.3.0.1216)
|
|
|
|
|