Typing non-english in Note of Element

[Son Ly Hung]

Hi all,

I have switched on JET 4.0 in Option menu, I also copied JET4_Base project to EA installation folder. After all preparation steps, I created new project base on JET4_Base template.

I can type unicode character for element name but I cannot type unicode in Notes section of one Element. I typed my note in word then copied this to Note section and my project can display & save this unicode character very well.

What do I have to do in order to type unicode character in Note of one Element?

Thanks!

[MMA]

your version of EA?

[skiwi]

1209

Yes, I seem to have this problem too.
Seems to be a regression from 1107

I can't enter the character [ch257] into a note field using the M[ch257]ori keyboard.

See unicode


This is really weird, as I have carried out extensive tests, and the only field I can find problems with keyboard entry is the notes field. But then that field has always had problems (see elsewhere for issues with pasting tables for example)

[Eve]

I'd be interested to know what language the original poster is trying to type in.

As for M[ch257]ori, that text was:

• typed into an EA notes field
• with the character sequence M`aori with Windows set to use a M[ch257]ori keyboard layout
• using the latest build of EA
• round tripped to a MySQL database
• Pasted into my browser window.

ie. I can't reproduce your problem.

[skiwi]

As for M[ch257]ori, that text was:

• typed into an EA notes field
• with the character sequence M[ch257]ori with Windows set to use a M[ch257]ori keyboard layout
• using the latest build of EA
• round tripped to a MySQL database
• Pasted into my browser window.

ie. I can't reproduce your problem.

Thanks very much for looking into that. That is frustrating. I can paste "[ch257]" into a notes field, just not enter it. But entry works fine everywhere else.
And I'm using jet 4 DB, 1209 (moving to 1213 and day now!)
Wish there was something else I could try

• input language is English (New Zealand) - Maori
• only keyboard is Maori

[MMA]

This is really weird, as I have carried out extensive tests, and the only field I can find problems with keyboard entry is the notes field. But then that field has always had problems (see elsewhere for issues with pasting tables for example)

Hi Skiwi,

How to read your picture? :-/

Could you say in detail what problem in which part of the picture had demonstrated?

Thanks
MMA

[skiwi]

My picture is simply illustrating that all these displayed different entities could "hold" - and therefore display - the unicode data I needed them too
(this wasn't the case when I first created the diagram several version ago).

The issue is now that while all fields can contain unicode data, I have a problem entering from the keyboard (but not by copying and pasting) unicode data. Go figure.

[Son Ly Hung]

I have a problem entering from the keyboard (but not by copying and pasting) unicode data. Go figure.

It is exact problem that I want to describe. Trying entering unicode (Vietnamese) into Note field, and it's go wrong.

[qwerty]

Maybe you need to ask some EA trainers nearby to provide one of your local keyboards. Or - Sparx will spend that investment to improve its international product a little bit.

q.

[Paul Lotz]

I can enter an [ch257] in a Note using the Maori keyboard.  That much is good.

I have two issues:
1) When I close EA (1213) and reopen it the note has just a regualar 'a' in it, without the macron.  (Yes, I switched to a Jet 4 database.)
2) I can't enter a macron in the value field for an attribute.  (Yes, I know that seems like an odd thing to want to do, but it is essential for the particular model I want to make.)

Suggestions?

Paul

[Paul Lotz]

Curiously, there are no problems with ñ or á.  Both work in notes and in attribute values and display correctly even after restarting EA.  Can we do the same for [ch257]?

[skiwi]

Sparx have been unable to rectify this in over five years ...
despite repeated bug reports, but it would be really good if you could re-report it

[Eve]

Paul, it sounds like you don't have any problems typing the accents. That then sounds like you're not having the issue skiwi was having either.

1. Does an [ch257] round-trip in any field, or is it just a problem with the notes? Is it the same for typing as copy and paste? (Note - Enabling the JET 4 option in EA isn't the same as using a JET 4 model. Both are needed for unicode support in any field)
2. Exactly which field are you using to set the attribute default? I tried both the inline field in the table and the dialog.  Both worked with typing and round-tripped successfully. Is the macron not showing up at all or being lost at some point?
3. What is your system code-page set to? The characters that you say work are included as part of the default Windows-1252 English code page, which would explain why it's going wrong if unicode isn't being used for any reason.

Skiwi, when you say we've been unable to rectify it for five years, how many of those were you using a JET 3.5 database while asserting that you were using JET 4? Then the one issue that you still have outstanding doesn't seem reproduceable by anyone except you.

[skiwi]

Good question. We use SQL Server and Jet 4.
I may have confused Jet 3 at least once, in a repository I created to test the bug.

However in our production models the use of macronised characters is common, and it quickly becomes apparent when you cannot enter a macronised character (background - I use English (NZ) and M[ch257]ori keyboard where entering a character with a macron is as simple as pressing the "`" key followed by a vowel, viz "[ch363]").

Just to confirm, I fired up EA 1213 Corporate with a SQL Server (2008 R2) back end, Windows 7 Enterprise 64bit client.
I created a package, and entered m[ch257]cr[ch333]n[ch299]s[ch275]d words in every field I could. See the following image. The ext in blue was not entered, it was pasted.



So while I may be the only person who has reported the bug, and it is difficult to recreate, I have consistently been able to repeat it across EA versions and for SQL Server and Jet4 repositories.

Note that in options under General "Use Jet 4.0" is set, this seems to be the only way to confirm that a Jet 4 Access database is being used.

And just for my own satisfaction I fired up a Jet 4 repository and exactly the same thing happened. It is not possible to enter from the keyboard a character such as "[ch333]" into the notes field (all other fields appear to work properly).

[Eve]

Note that in options under General "Use Jet 4.0" is set, this seems to be the only way to confirm that a Jet 4 Access database is being used.

Actually, I'd say the opposite is true. Disable it, restart EA and try connecting to your database. If it connects it's not a JET 4 database.

As I understand it, your current problem is specific to typing with the Maori keyboard. Once the characters are entered, you don't have any problems with round-trip. I don't know why the problem with the keyboard doesn't happen for me. (I assume it does impact others at your workplace)