Hebrew Product Name


https://forum.kartris.com/Topic2774.aspx
Print Topic | Close Window

By bpaluch - Thu 23 Jan 2014
Hi,

Using v2.5008, I'm having trouble entering Hebrew into the product name field, it generates 'general database error'.

I added Hebrew as a language, but I entered the Hebrew text in the 'English' section, because I don't really want to run the site in both languages, but rather to allow either language in the same 'languageid' - some products will be listed in English and some in Hebrew.





-----------------------------------------------------------------------------
>> ProductsBLL._AddProduct
-----------------------------------------------------------------------------
>> System.ApplicationException
>> 1/23/2014 10:57:18 AM
>> Version:2.5008
>> URL:http://kosherconsignments.com/Admin/_ModifyProduct.aspx?ProductID=0&CategoryID=6&strParent=0
>> 47.21.132.50
>> CUSTOM MESSAGE:
Database Error: A general error has occurred.Error occurred while processing the operation.
>> MESSAGE:
Error occurred while processing the operation.
>> STACK:
at ProductsBLL._AddProduct(DataTable ptblElements, String pParentsList, Int32& pProductID, Boolean pLive, Byte pFeatured, String pOrderVersionsBy, Char pVersionsSortDirection, Char pReviews, Char pVersionDisplayType, Int32 pSupplier, Char pProductType, Int32 pCustomerGroupID, Int32 pUser, String& strMsg)
By shulemj - Thu 13 Dec 2018
Anyone ever found a fix for this?
By Tiggywiggler - Sat 29 Dec 2018
Do you have an example text that we can try and insert and then we can see what the result is? The database fields themselves are NVARCHAR so it shouldn't matter what language you are inputting as it should be stored anyway. It may be that some of the VB.Net code is trying to read this as a VARCHAR string and not handling it correctly.

If you can share a sample string I can try and reproduce the fault.