Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.ID as ID13_0_, this_.ADDRESS as ADDRESS13_0_, this_.DESCRIPTION as DESCRIPT3_13_0_, this_.DISABLED as DISABLED13_0_, this_.EMAIL as EMAIL13_0_, this_.FAX as FAX13_0_, this_.NAME as NAME13_0_, this_.NO_OF_ROOMS as NO8_13_0_, this_.TELEPHONE as TELEPHONE13_0_, this_.RATING as RATING13_0_, this_.WEBSITE as WEBSITE13_0_, this_.FB_NAME as FB12_13_0_, this_.TRIPADVISOR_ID as TRIPADV13_13_0_, this_.TRIPADVISOR_PARTNER_ID as TRIPADV14_13_0_, this_.ZIPCODE as ZIPCODE13_0_, this_.PREFIX as PREFIX13_0_, this_.AUTO_CLOSE as AUTO17_13_0_, this_.DEFAULT_SHOWING_GUEST as DEFAULT18_13_0_, this_.DEFAULT_NIGHTS as DEFAULT19_13_0_, this_.ORDER_OPTION as ORDER20_13_0_, this_.ORDER_DIRECTION as ORDER21_13_0_, this_.FORCE_ROOM_ORDER as FORCE22_13_0_, this_.SEARCH_TREATMENT as SEARCH23_13_0_, this_.PERCENT_PAYMENT as PERCENT24_13_0_, this_.COMMISSION as COMMISSION13_0_, this_.PROMOTION_POINT as PROMOTION26_13_0_, this_.GATEWAY as GATEWAY13_0_, this_.GATEWAY_REF_NO_1 as GATEWAY28_13_0_, this_.GATEWAY_REF_NO_2 as GATEWAY29_13_0_, this_.GATEWAY_REF_NO_3 as GATEWAY30_13_0_, this_.GATEWAY_REF_NO_4 as GATEWAY31_13_0_, this_.GATEWAY_REF_NO_5 as GATEWAY32_13_0_, this_.BN_CODE as BN33_13_0_, this_.GATEWAY_URL as GATEWAY34_13_0_, this_.REQUIRE_BANK_TRANSFER as REQUIRE35_13_0_, this_.CREATED_DATE as CREATED36_13_0_, this_.UPDATED_DATE as UPDATED37_13_0_, this_.CREATED_BY as CREATED38_13_0_, this_.UPDATED_BY as UPDATED39_13_0_, this_.PUBLIC_KEY as PUBLIC40_13_0_, this_.CUSTOM_PAYMENT_GATEWAY as CUSTOM41_13_0_, this_.CURRENCY as CURRENCY13_0_, this_.LANGUAGE as LANGUAGE13_0_, this_.SEO_NAME as SEO44_13_0_, this_.DEFAULT_RATE_NAME as DEFAULT45_13_0_, this_.DEFAULT_RATE_DESCRIPTION as DEFAULT46_13_0_, this_.HIDE_BAR as HIDE47_13_0_, this_.ALWAYS_HIDE_BAR as ALWAYS48_13_0_, this_.DEFAULT_TAXESEVICE_DESCRIPTION_ID as DEFAULT49_13_0_, this_.PACKAGE_FIRST as PACKAGE50_13_0_, this_.SEPARATE_PROMOTION_PACKAGE as SEPARATE51_13_0_, this_.HIDE_ROOM_NOT_AVAILABLE as HIDE52_13_0_, this_.ALLOTMENT_ALGORITHM as ALLOTMENT53_13_0_, this_.DEMO as DEMO13_0_, this_.PINNED as PINNED13_0_, this_.SCORE as SCORE13_0_, this_.SALE_AMOUNT as SALE57_13_0_, this_.ALLOTMENT_WARNING as ALLOTMENT58_13_0_, this_.FORCE_PREPAYMENT as FORCE59_13_0_, this_.FORCE_PREPAYMENT_PERCENT as FORCE60_13_0_, this_.OPTIONAL_CC_INFO as OPTIONAL61_13_0_, this_.LATITUDE as LATITUDE13_0_, this_.LONGITUDE as LONGITUDE13_0_, this_.HPA_ENABLED as HPA64_13_0_, this_.GHA_ENABLED as GHA65_13_0_, this_.AUTO_EXPAND as AUTO66_13_0_, this_.AUTO_SEARCH as AUTO67_13_0_, this_.ENABLE_IP_TRACK as ENABLE68_13_0_, this_.LANDING_PROMOTION as LANDING69_13_0_, this_.ACCOMM_DESC as ACCOMM70_13_0_, this_.FACILITY_DESCRIPTION as FACILITY71_13_0_, this_.LOCATION_LINK as LOCATION72_13_0_, this_.LOCATION_DESCRIPTION as LOCATION73_13_0_, this_.CODE_LABEL as CODE74_13_0_, this_.CODE_BUTTON as CODE75_13_0_, this_.ENABLE_VIP as ENABLE76_13_0_, this_.SHOW_CHECK_OUT as SHOW77_13_0_, this_.SHOW_ADDRESS as SHOW78_13_0_, this_.REQUIRE_ADDRESS as REQUIRE79_13_0_, this_.ADVANCED_DEPOSIT as ADVANCED80_13_0_, this_.ADD_ENH_INTO_DEPO as ADD81_13_0_, this_.AP_USER as AP82_13_0_, this_.AP_PASS as AP83_13_0_, this_.VERSION as VERSION13_0_, this_.EXCLUDE_DEPOSIT_TAX as EXCLUDE85_13_0_, this_.OPEN_AFTER_CANCEL as OPEN86_13_0_, this_.HOTEL_LOGO as HOTEL87_13_0_, this_.HOTEL_MAP as HOTEL88_13_0_, this_.PORTAL_IMAGE as PORTAL89_13_0_, this_.HOTEL_SKIN_ID as HOTEL90_13_0_, this_.WEEKDAY as WEEKDAY13_0_, this_.WEEKEND as WEEKEND13_0_, this_.HOTEL_GROUP as HOTEL93_13_0_, this_.PARTNER_ID as PARTNER94_13_0_, this_.AREA as AREA13_0_, this_.PROVINCE as PROVINCE13_0_, this_.DISTRICT as DISTRICT13_0_, this_.SUB_DISTRICT as SUB98_13_0_, this_.CATEGORY as CATEGORY13_0_, this_.COUNTRY as COUNTRY13_0_ from HOTEL this_ where this_.PREFIX=?]; SQL state [HY000]; error code [1267]; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='

« Back