Export global table with 3-byte characters to database

[yokota_t]

[ FlexSim 21.0.6 ]

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.

[joerg_vogel_HsH]

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

[yokota_t]

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.

[ryan_c10]

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.

[yokota_t]

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?

[kavika_faleumu]

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.

[Jeanette_Fullmer]

Hello @Yokota T,

Were you able to find a solution? If not, could you please provide a response to @Kavika F's question.

[yokota_t]

The database column names I have tried and failed are 取得時刻, 出荷ID, 格納ID, 搬送先ID,and 品番.

The error message was

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

Thank you.

[kavika_faleumu]

Okay I was able to replicate your error. I will report this issue to the developers and have a solution in a future version.

[yokota_t]

Hello, @Kavika F

That's good to know. Best regards.