-- Repair the Devanagari names the legacy import double-encoded.
--
-- Twelve supervisor registrations came across as mojibake: their UTF-8 bytes
-- were read as Windows-1252 somewhere in the old site's export, so
-- "डॉ शिवजी सिंह" was stored as "डॉ शिवजी सिंह".
-- Eight of them are on the public register after V35, where they are simply
-- unreadable. They are real people, so the answer is to repair the text rather
-- than hide them.
--
-- Written as explicit values rather than an encoding round-trip in SQL. The
-- corruption is not uniform — it carries bytes Windows-1252 leaves undefined,
-- which makes convert_from/convert_to fail outright — and one row's address was
-- truncated mid-character when it was first imported, so its dangling bytes
-- cannot be decoded at all. Each value below was recovered and checked to be
-- Devanagari before being written down; the truncated address keeps the 100
-- characters that survived, since the rest was already lost.
--
-- The other two registers are clean: this is twelve rows in the supervisor
-- register and nowhere else.

UPDATE registry_entries
   SET name = 'डा. गिरिराज शरण अग्रवाल',
       designation = 'पूर्व अध्य्क्ष हिन्दी विभाग',
       university = 'रोहिलखंड विश्वविद्यालय',
       subject = 'हिन्दी',
       interest = 'नाटक',
       address = '16 सहित्य विहार, बिजनौर उ.प्र. 246701'
 WHERE type = 'SUPERVISOR' AND legacy_id = 64;

UPDATE registry_entries
   SET name = 'पंकज कुमार सिंह',
       designation = 'जे. आर. एफ. शोध-छात्र',
       university = 'महात्मा गांधी अंतरराष्ट्रीय हिंदी विश्वविद्यालय, वर्धा',
       subject = 'खादी का अर्थशास्त्र : एक अध्ययन',
       interest = 'गांधी-विचार',
       address = 'अहिंसा एवं शांति अध्ययन विभाग
महात्मा गांधी अंतरराष्ट्रीय हिंदी विश्वविद्यालय, वर्धा 
पिन-442005(म'
 WHERE type = 'SUPERVISOR' AND legacy_id = 74;

UPDATE registry_entries
   SET name = 'डॉ. विजयकुमारन सी.पी.वी.',
       designation = 'निवृत्त आचार्य एवं अतिथि व्याख्याता',
       university = 'केरल केंद्रीय विश्वविद्यालय, कासरगोड',
       subject = 'हिंदी',
       interest = 'तुलनात्मक साहित्य, अनुवाद अध्ययन, सौंदर्यशास्त्र, भक्ति',
       address = 'निवृत्त आचार्य एवं अतिथि व्याख्याता, हिन्दी विभाग, केरल केन्द्रीय विश्वविदयालय, कासरगोड, केरल - 671'
 WHERE type = 'SUPERVISOR' AND legacy_id = 399;

UPDATE registry_entries
   SET name = 'डॉ. विजयकुमारन सी.पी.वी.',
       designation = 'निवृत्त आचार्य एवं अतिथि व्याख्याता',
       university = 'केरल केंद्रीय विश्वविद्यालय, कासरगोड',
       subject = 'हिंदी विभाग',
       interest = 'तुलनात्मक साहित्य, अनुवाद अध्ययन, सौंदर्यशास्त्र, भक्ति',
       address = 'निवृत्त आचार्य एवं अतिथि व्याख्याता, हिन्दी विभाग, केरल केन्द्रीय विश्वविदयालय, कासरगोड, केरल - 671'
 WHERE type = 'SUPERVISOR' AND legacy_id = 400;

UPDATE registry_entries
   SET name = 'डॉ. विजयकुमारन सी.पी.वी.',
       designation = 'निवृत्त आचार्य एवं अतिथि व्याख्याता',
       university = 'केरल केंद्रीय विश्वविद्यालय, कासरगोड',
       subject = 'हिंदी विभाग',
       interest = 'तुलनात्मक साहित्य, अनुवाद अध्ययन, सौंदर्यशास्त्र, भक्ति',
       address = 'निवृत्त आचार्य एवं अतिथि व्याख्याता, हिन्दी विभाग, केरल केन्द्रीय विश्वविदयालय, कासरगोड, केरल - 671'
 WHERE type = 'SUPERVISOR' AND legacy_id = 401;

UPDATE registry_entries
   SET name = 'डॉ कल्पना बाजपेयी',
       designation = 'असिस्टेंट प्रोफेसर',
       university = 'रानी चेन्नम्मा विश्वविद्यालय, बेलगवि',
       subject = 'हिंदी',
       interest = 'हिंदी कथा साहित्य',
       address = 'SMQ 83/2 North Camp ATS Sambra
Belagavi, Karnataka 591124'
 WHERE type = 'SUPERVISOR' AND legacy_id = 591;

UPDATE registry_entries
   SET name = 'डॉ शिवजी सिंह',
       designation = 'सहायक प्राध्यापक भौतिक विज्ञान शिक्ष',
       university = 'Govt College of Education under Panjab University, Chandigarh',
       subject = 'Physics,/Education',
       interest = 'Science Education, Physics Education, Philosophy of Education, Value Education, Indian Perspective of Teacher Education',
       address = 'राजकीय शिक्षा महाविद्यालय
सेक्टर 20 डी चंडीगढ़
160020 केंद्रशासित क्षेत्र'
 WHERE type = 'SUPERVISOR' AND legacy_id = 772;

UPDATE registry_entries
   SET name = 'डॉ शिवजी सिंह',
       designation = 'सहायक प्राध्यापक भौतिक विज्ञान शिक्ष',
       university = 'Govt College of Education under Panjab University, Chandigarh',
       subject = 'Physics,/Education',
       interest = 'Science Education, Physics Education, Philosophy of Education, Value Education, Indian Perspective of Teacher Education',
       address = 'राजकीय शिक्षा महाविद्यालय
सेक्टर 20 डी चंडीगढ़
160020 केंद्रशासित क्षेत्र'
 WHERE type = 'SUPERVISOR' AND legacy_id = 773;

UPDATE registry_entries
   SET name = 'डॉ शिवजी सिंह',
       designation = 'सहायक प्राध्यापक भौतिक विज्ञान शिक्ष',
       university = 'Govt College of Education under Panjab University, Chandigarh',
       subject = 'Physics,/Education',
       interest = 'Science Education, Physics Education, Philosophy of Education, Value Education, Indian Perspective of Teacher Education',
       address = 'राजकीय शिक्षा महाविद्यालय
सेक्टर 20 डी चंडीगढ़
160020 केंद्रशासित क्षेत्र'
 WHERE type = 'SUPERVISOR' AND legacy_id = 774;

UPDATE registry_entries
   SET name = 'डॉ. राजेन्द्र कुमार सिंघवी',
       designation = 'अस्सिस्टेंट प्रोफेसर-हिंदी',
       university = 'राजकीय महाविद्यालय, चित्तौड़गढ़',
       subject = 'हिंदी विभाग',
       interest = 'गद्य एवं काव्य',
       address = 'एफ 6-7,रजत विहार, निम्बाहेड़ा
जिला-चित्तौड़गढ़, राजस्थान
पिन-312601'
 WHERE type = 'SUPERVISOR' AND legacy_id = 776;

UPDATE registry_entries
   SET name = 'कविता यादव',
       designation = 'अध्यापक',
       university = 'NgBU',
       subject = 'Hindi',
       interest = 'Premchandra',
       address = 'C7 kailash nagar kanpur'
 WHERE type = 'SUPERVISOR' AND legacy_id = 838;

UPDATE registry_entries
   SET name = 'विवेक मिश्र',
       designation = 'विद्यार्थी',
       university = 'काशी हिन्दू विश्वविद्यालय',
       subject = 'हिन्दी',
       interest = 'कथा साहित्य',
       address = 'ग्राम सोनहन पोस्ट.साबूकपूर जिला अम्बेडकर नगर उत्तर प्रदेश 224143'
 WHERE type = 'SUPERVISOR' AND legacy_id = 901;