utf8 al pasar datos de sql server a manticore

General Discussions - English
1

Hello, I have a SQL server database, when indexing to manticore search, manticore does not recognize Latin characters, ñ, accent, I have tried everything, the utf8 variables are already present in manticore, but I cannot solve the problem, please help

2

Please provide a reproducible example.

3

write ni♦ez, For example, in my SQL database it says niñez and in Manticore the data appears ni♦ez

4

I’m not an expert in MS SQL. If you provide a reproducible example based on an MS SQL docker image, I can look into it.

E.g. I can start MS SQL and log in to it:

docker run --rm -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourStrong_Password" -e "MSSQL_PID=Evaluation" -p 1433:1433  --name mssql --hostname sqlpreview -d mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04

docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P yourStrong_Password

but don’t know how to populate it with data to reproduce your issue.