Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issues with Nordic Characters #223

Open
stefkla opened this issue May 22, 2024 · 2 comments
Open

Issues with Nordic Characters #223

stefkla opened this issue May 22, 2024 · 2 comments
Labels
idle Inactive for 14 days waiting-for-user Waiting for inputs from user

Comments

@stefkla
Copy link

stefkla commented May 22, 2024

Hi !
My action looks like this:

    - name: Deploy Post-script Database 
      uses: Azure/sql-action@v1
      with: 
        server-name: ${{steps.ServerName}}
        connection-string: ${{...sql-pipelineconfig-connectionstring}}
        sql-file: ${{ github.workspace }}\Path\to\script\file.sql

The issue I am facing is that nordic characters - ÅÆØ - are replaced by garbage symbols, E.g:
'Kårstø' becomes 'KÃ…RSTØ'

The Collation is set correctly on the Azure SQL database, and we can run the script manually in in SQL Server Management Studio to get the correct output.

Tried a couple of different things, among others verifying database collation, column types, that the generated files have the correct UTF encoding.
The last thing I can think of is that it is possibly an issue with the action

@stefkla stefkla added the need-to-triage Requires investigation label May 22, 2024
Copy link

github-actions bot commented Jun 5, 2024

This issue is idle because it has been open for 14 days with no activity.

@github-actions github-actions bot added the idle Inactive for 14 days label Jun 5, 2024
@zijchen
Copy link
Contributor

zijchen commented Jun 27, 2024

Hello, can you share which runner image you're using and the database collation? I tested with Ubuntu 22.04 and a database with collation Danish_Norwegian_CI_AS but could not reproduce the error. I inserted nordic text into a table with nordic name and everything is working as expected.

@dzsquared dzsquared added waiting-for-user Waiting for inputs from user and removed need-to-triage Requires investigation labels Sep 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
idle Inactive for 14 days waiting-for-user Waiting for inputs from user
Projects
None yet
Development

No branches or pull requests

3 participants