how to define long varchar in hazelcast python client? about hazelcast-python-client HOT 7 CLOSED

fix it 👍
Teşekkür ederim – Thank You

from hazelcast-python-client.

@6273parastu Is the category_name equal to jkhbjhbkjqwertyuiop[]asdfghjkl;'/.mnbvcxzasdfgqewrtyhygjutjqazwsxedcrfvtgbnhytgujmnhy15978huinhtrfvgdeswapkmjbgjnbhytqwexzasfeaqijnhb531254872gtdghgggggga", ?

from hazelcast-python-client.

No, row_database equal to jkhbjhbkjqwertyuiop[]asdfghjkl;'/.mnbvcxzasdfgqewrtyhygjutjqazwsxedcrfvtgbnhytgujmnhy15978huinhtrfvgdeswapkmjbgjnbhytqwexzasfeaqijnhb531254872gtdghgggggga",

from hazelcast-python-client.

@6273parastu I see. You need to escape the single quote in your row_database. You can do that by using double single quotes. So,

jkhbjhbkjqwertyuiop[]asdfghjkl;'/.mnbvcxzasdfgqewrtyhygjutjqazwsxedcrfvtgbnhytgujmnhy15978huinhtrfvgdeswapkmjbgjnbhytqwexzasfeaqijnhb531254872gtdghgggggga",

should become

jkhbjhbkjqwertyuiop[]asdfghjkl;''/.mnbvcxzasdfgqewrtyhygjutjqazwsxedcrfvtgbnhytgujmnhy15978huinhtrfvgdeswapkmjbgjnbhytqwexzasfeaqijnhb531254872gtdghgggggga",

from hazelcast-python-client.

raw_database =  'YsSDYs9in24zYqiDYqNmE24zYqiDZgdix2YjYtNuMINmB24zZhtin2YQg2KzYp9mFINit2LDZgduMCgrwn5S52KjZhNuM2Kog2YHYsdmI2LTbjCDYqNin2LLbjCDZgduM2YbYp9mEINis2KfZhSDYrdiw2YHbjCDYqNuM2YYg2K'
query = f"INSERT INTO {category_name} VALUES(1, 146546321654, {raw_database});"
reponse = client.sql.execute(query)

i get this error:
HazelcastSqlError("Length of identifier 'YsSDYs9in24zYqiDYqNmE24zYqiDZgdix2YjYtNuMINmB24zZhtin2YQg2KzYp9mFINit2LDZgduMCgrwn5S52KjZhNuM2Kog2YHYsdmI2LTbjCDYqNin2LLbjCDZgduM2YbYp9mEINis2KfZhSDYrdiw2YHbjCDYqNuM2YYg2K' must be less than or equal to 128 characters", None)

from hazelcast-python-client.

@6273parastu put your raw_database variable in between single quotes:

query = f"INSERT INTO {category_name} VALUES(1, 146546321654, '{raw_database}');"

from hazelcast-python-client.

No problem at all. I am closing this issue then.

from hazelcast-python-client.