# Unable to render lowercase french accent character in mssql

**URL:** <https://www.ruby-forum.com/t/unable-to-render-lowercase-french-accent-character-in-mssql/157862>\
**Category:** Rails\
**Created:** [January 16, 2009, 2:38am UTC](https://www.ruby-forum.com/t/unable-to-render-lowercase-french-accent-character-in-mssql/157862 "2009-01-16T02:38:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pengzhi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ce7236/32.png) [@Pengzhi](https://www.ruby-forum.com/u/Pengzhi)\
**Post date:** [January 16, 2009, 2:38am UTC](https://www.ruby-forum.com/t/unable-to-render-lowercase-french-accent-character-in-mssql/157862/1 "2009-01-16T02:38:07Z")

</div>

Hello,

We initially save french characters using friendly html code, ie:  
Ç into our db. Problems started when user tried to save actual  
accented characters, ie:Ç, in the forms. The accented characters  
become garbled and unable to be render correctly to views. This only  
happens on lower case french characters. We tried collation but not  
sure if we are even using the right one. The server is running linux,  
and running Ruby 1.8.6, any help at this point will be very much  
appreciated. Thanks!!!