problem with encoding in Model Issues

[ernest]

Hi,

I have a problem with some czech characters in editing model issue. In Maintenance window I can add a model issue with czech characters, but when I save the issue and reopen the dialog the Name field contains some wrong characters.

I tried these characters

and after saving and reopening the dialog I got this


Will you help me?
I have EA 6.1.791
Thanks

ernest

[thomaskilian]

There have been posts regarding Czech chars here. Have you searched for them (can't actually help you)?

[ernest]

yes, I tried searching for string "czech" during last year at the forum and I found only "Problem with RTF report for Model Issues". I think, this is another problem.

Does anybody have the same problem?

[Jan ´Bary´ Glas]

Does anybody have the same problem?

It works well for me, build 6.1.792.
Cannot replicate.
Problems with Czech I suffered before:
when Czech (localized) MS Windows w/EN keyboard - problems with RTF generation (already fixed)
not described problem w/ RTF generation (from time to time it behaves strange w/custom templates, still no idea why, working on it)

Conclusion: I have problem with nothing inside the EA (considering Czech).

[ernest]

In EA version 6.1.792 the problem still persists. I tried another computer in our company (with the same version), and they have the problem too. We have Unicode version installed.

I don't have another problem with czech characters except this and the behavior which Bary described.

Could you remove the unpleasant behavior? Has anybody some idea, what to do/test?

[Jan ´Bary´ Glas]

 ernest, still cannot repeat.
what system do you have? (I have MS Windows XP English version.)

[Eve]

I'm not completely sure of your problem, but if you're using EAP files make sure that you're using JET 4.  (Tools | Options| General)  You may also need to get a JET4 base model.

If you're using a repository, make sure that the repository is set up to handle unicode characters.

[ernest]

I'm running WinXP Pro Cze SP2 and as a repository we have MS SQL 2000 Standard Edition SP3, Server collation SQL_Czech_CP1250_CI_AS. Database collation is the same.

ooops, I was looking into the database, into the table t_objectproblem and I noticed that the column Problem has varchar datatype whilst the column ProblemNotes and other has ntext and nvarchar. It's possible that this could cause the problem?

[«Midnight»]

That sounds entirely likely.

[ernest]

Yes, it works! Changing the datatype of the column from VARCHAR to NVARCHAR, solved my problem.
Thank you everybody

[Jan ´Bary´ Glas]

Superb, helps for the future in similar cases. Thanks a lot.

[Paolo F Cantoni]

Yes, it works! Changing the datatype of the column from VARCHAR to NVARCHAR, solved my problem.
Thank you everybody

As you can see, the Sparxians do monitor this forum, but it may be best to let them know formally...

Paolo

[ernest]

As you can see, the Sparxians do monitor this forum, but it may be best to let them know formally...

Paolo

I wanted to discuss the problem first.

And now, is it necessary to report a bug or will you solve the problem without the report?

[«Midnight»]

BTW, remember that this (changing from 8-bit to extended character types) will work - with appropriate adjustments - for Oracle, SQL Server, and Sybase repositories. I suspect similar adjustments will also work with the other repository types.