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.

Software Version:

FlexSim 21.0.6

· 9

Joerg Vogel commented · Jan 31 2022 at 7:23 AM

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 ·

Yokota T Joerg Vogel commented · Feb 04 2022 at 8:17 AM

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 ·

Ryan Clark commented · Feb 10 2022 at 1:10 AM

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 ·

Yokota T Ryan Clark commented · Jun 29 2022 at 2:48 PM

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 ·

Kavika F ♦ Yokota T commented · Aug 15 2022 at 4:02 PM

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 ·

Show more comments