question

Yokota T avatar image
0 Likes"
Yokota T asked Yokota T commented

Export global table with 3-byte characters to database

Hi all,

I'm trying to export my global table to the database(MySQL). But the exporting fails.

My guess is that because the column name has 3-byte characters. Is it possible to use 3-byte characters in the column name?

Using 3-byte characters is crucial for me because I'm Japanese.

Thanks.


FlexSim 21.0.6
databaseexportexport datadata export3-byte character
· 9
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel avatar image Joerg Vogel commented ·

Can you translate a Japanese 3-byte character into the byte metrics of [0,1] or hexadecimal number and export them as a string?

0 Likes 0 ·
Yokota T avatar image Yokota T Joerg Vogel commented ·
I can export Japanese 3-byte characters as cell values.

But when the column name of the Global Table includes Japanese character, I can't export that table regardless of its cell values.

0 Likes 0 ·
Ryan Clark avatar image Ryan Clark commented ·

Hi @Yokota T,

@Jordan Johnson suggested to try wrapping the column name in brackets. Does that fix your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·
Yokota T avatar image Yokota T Ryan Clark commented ·

Sorry for my very late reply.

Now I'm using FlexSimJapanese 22.0.4.

I tryed wrapping the column name that contains 3-byte characters in brackets.


1. When the Global Table column name contains 3-byte characters

Brackets worked well. I succeeded in export.


2. When the database column name contains 3-byte characters

Brackets didn't work. The error message was like the following.

exception: Exception thrown in database export: Unknown column '[取得時刻]' in 'field list'


What should I do if the database column name has 3-byte characters?

1 Like 1 ·
Kavika F avatar image Kavika F ♦ Yokota T commented ·
Hey @Yokota T, could you give me an example of some 3-byte characters you're using for your Database column names? I've tested a few 3-byte characters and haven't had any luck replicating the error.
0 Likes 0 ·
Show more comments
Show more comments

0 Answers