Answered: Unexpected behavior with pg_trgm and special characters
Hello guys. First, thanks for the awesome work.
I have encountered some inconsistency regarding the pg_tgrm extension on Neon.
When I use the show_trgm, it has weird behaviors when using Japanese characters:
Example with no special characters: Works normally.
Example with japanese characters: Skips everything in Neon.
Neon:
My Docker PgSQL:
When I switched my staging environment from Neon to a normal PostgreSQL in Docker, it worked without any problems.
Please, is there any configuration that I can do in Neon to support special and Japanese characters.
Thank you in advance.
Will
I have encountered some inconsistency regarding the pg_tgrm extension on Neon.
When I use the show_trgm, it has weird behaviors when using Japanese characters:
Example with no special characters: Works normally.
SELECT show_trgm('res'), show_trgm('very interesting place'), similarity('res', 'very interesting place');
Example with japanese characters: Skips everything in Neon.
SELECT show_trgm('面白い'), show_trgm('とても面白い場所'), similarity('面白い', 'とても面白い場所');
Neon:
My Docker PgSQL:
When I switched my staging environment from Neon to a normal PostgreSQL in Docker, it worked without any problems.
Please, is there any configuration that I can do in Neon to support special and Japanese characters.
Thank you in advance.
Will
